Accessing a NotesSQL Datasource from MS SQL Server

Notes/Domino 8 Forum

Subject: Accessing a NotesSQL Datasource from MS SQL Server

Feedback Type: Question

Product Area: Domino Server

Technical Area: Functionality

Platform: Windows 2003 server

Release: All

Reproducible: Not applicable

I have set up and configured NotesSQL on a Windows 2003 server. I was able to add a system DSN that points to a test database on my Domino development server. So far so good.

What I ultimately want to do is to add a trigger to a SQL Server database table that monitors for updates and then update a corresponding Notes database.

I basically am wondering how to talk to the datasource through SQL code that will run on the SQL server. I found this article on Database Journal:

http://www.databasejournal.com/features/mssql/article.php/10894_3462011_1/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm

It outlines how to set up the datasource as a "Linked Server". I did this and was able to query the datasource via the "openquery" statement. However, I am wondering how I can just to a simple statement like this:

select * from vwTest

Management Studio is unaware of the database unless I use the "openquery" statement. I guess the problem is that I don't know how to reference the datasource from SQL Server Management Studio. It seems simple and I would appreciate it if anyone could lend a hand.

Thanks in advance!

Feedback number WEBB7ZMMK2 created by ~Frank Elgerovergon on 01/12/2010

Status: Open
Comments: